/*
 * Reportes.java
 *
 * Created on 10/09/2008, 10:37:31 AM
 */
 
package webadtafa_ec;

import com.sun.data.provider.impl.CachedRowSetDataProvider;
import com.sun.rave.web.ui.appbase.AbstractPageBean;
import com.sun.rave.web.ui.component.Body;
import com.sun.rave.web.ui.component.Button;
import com.sun.rave.web.ui.component.Calendar;
import com.sun.rave.web.ui.component.DropDown;
import com.sun.rave.web.ui.component.PanelLayout;
import com.sun.rave.web.ui.component.RadioButtonGroup;
import com.sun.rave.web.ui.model.SingleSelectOptionsList;
import escr.clases.Captura;
import escr.persistencia.Especialidad;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.HashMap;
import java.util.Map;
import javax.faces.FacesException;


/**
 * <p>Page bean that corresponds to a similarly named JSP page.  This
 * class contains component definitions (and initialization code) for
 * all components that you have defined on this page, as well as
 * lifecycle methods and event handlers where you may add behavior
 * to respond to incoming events.</p>
 *
 * @author Aditardo
 */
public class Reportes extends AbstractPageBean {
    // <editor-fold defaultstate="collapsed" desc="Managed Component Definition">

    /**
     * <p>Automatically managed component initialization.  <strong>WARNING:</strong>
     * This method is automatically generated, so any user-specified code inserted
     * here is subject to being replaced.</p>
     */
    private void _init() throws Exception {
        body1.setStyle("-rave-layout: grid");
        grupOpDefaultOptions.setOptions(new com.sun.rave.web.ui.model.Option[]{new com.sun.rave.web.ui.model.Option("1", "Por Fecha y Especialidad"), new com.sun.rave.web.ui.model.Option("2", "Por fecha"), new com.sun.rave.web.ui.model.Option("3", "Por Especialidad")});
        grupOpDefaultOptions.setSelectedValue("1");
        
        cal_ini.setValue(new Date("01/01/2007"));
        cal_fin.setValue(new Date());
 
        
    
    }
    private Calendar calendarInicio = new Calendar();

    public Calendar getCalendarInicio() {
        return calendarInicio;
    }

    public void setCalendarInicio(Calendar c) {
        this.calendarInicio = c;
    }
    private Calendar calendariofin = new Calendar();

    public Calendar getCalendariofin() {
        return calendariofin;
    }

    public void setCalendariofin(Calendar c) {
        this.calendariofin = c;
    }
    
    private CachedRowSetDataProvider usuarioDataProvider = new CachedRowSetDataProvider();

    public CachedRowSetDataProvider getUsuarioDataProvider() {
        return usuarioDataProvider;
    }

    public void setUsuarioDataProvider(CachedRowSetDataProvider crsdp) {
        this.usuarioDataProvider = crsdp;
    }
    private Body body1 = new Body();

    public Body getBody1() {
        return body1;
    }

    public void setBody1(Body b) {
        this.body1 = b;
    }
    private Button button1 = new Button();

    public Button getButton1() {
        return button1;
    }

    public void setButton1(Button b) {
        this.button1 = b;
    }
    private SingleSelectOptionsList grupOpDefaultOptions = new SingleSelectOptionsList();

    public SingleSelectOptionsList getGrupOpDefaultOptions() {
        return grupOpDefaultOptions;
    }

    public void setGrupOpDefaultOptions(SingleSelectOptionsList ssol) {
        this.grupOpDefaultOptions = ssol;
    }
    private RadioButtonGroup grupOp = new RadioButtonGroup();

    public RadioButtonGroup getGrupOp() {
        return grupOp;
    }

    public void setGrupOp(RadioButtonGroup rbg) {
        this.grupOp = rbg;
    }
    private PanelLayout contenedorReporte = new PanelLayout();

    public PanelLayout getContenedorReporte() {
        return contenedorReporte;
    }

    public void setContenedorReporte(PanelLayout pl) {
        this.contenedorReporte = pl;
    }
    private Calendar cal_fin = new Calendar();

    public Calendar getCal_fin() {
        return cal_fin;
    }

    public void setCal_fin(Calendar c) {
        this.cal_fin = c;
    }
    private Calendar cal_ini = new Calendar();

    public Calendar getCal_ini() {
        return cal_ini;
    }

    public void setCal_ini(Calendar c) {
        this.cal_ini = c;
    }
    private PanelLayout dcalendar = new PanelLayout();

    public PanelLayout getDcalendar() {
        return dcalendar;
    }

    public void setDcalendar(PanelLayout pl) {
        this.dcalendar = pl;
    }
    private PanelLayout despecialidades = new PanelLayout();

    public PanelLayout getDespecialidades() {
        return despecialidades;
    }

    public void setDespecialidades(PanelLayout pl) {
        this.despecialidades = pl;
    }
    private DropDown ddlEspecialidad = new DropDown();

    public DropDown getDdlEspecialidad() {
        return ddlEspecialidad;
    }

    public void setDdlEspecialidad(DropDown dd) {
        this.ddlEspecialidad = dd;
    }
    
    

    // </editor-fold>

    /**
     * <p>Construct a new Page bean instance.</p>
     */
    public Reportes() {
    }

    /**
     * <p>Callback method that is called whenever a page is navigated to,
     * either directly via a URL, or indirectly via page navigation.
     * Customize this method to acquire resources that will be needed
     * for event handlers and lifecycle methods, whether or not this
     * page is performing post back processing.</p>
     * 
     * <p>Note that, if the current request is a postback, the property
     * values of the components do <strong>not</strong> represent any
     * values submitted with this request.  Instead, they represent the
     * property values that were saved for this view when it was rendered.</p>
     */
    @Override
    public void init() {
        // Perform initializations inherited from our superclass
        super.init();
        // Perform application initialization that must complete
        // *before* managed components are initialized
        // TODO - add your own initialiation code here
        
        // <editor-fold defaultstate="collapsed" desc="Managed Component Initialization">
        // Initialize automatically managed components
        // *Note* - this logic should NOT be modified
        try {
            _init();
        } catch (Exception e) {
            log("Reportes Initialization Failure", e);
            throw e instanceof FacesException ? (FacesException) e: new FacesException(e);
        }
        
        // </editor-fold>
        // Perform application initialization that must complete
        // *after* managed components are initialized
        // TODO - add your own initialization code here
    }

    /**
     * <p>Callback method that is called after the component tree has been
     * restored, but before any event processing takes place.  This method
     * will <strong>only</strong> be called on a postback request that
     * is processing a form submit.  Customize this method to allocate
     * resources that will be required in your event handlers.</p>
     */
    @Override
    public void preprocess() {
    }

    /**
     * <p>Callback method that is called just before rendering takes place.
     * This method will <strong>only</strong> be called for the page that
     * will actually be rendered (and not, for example, on a page that
     * handled a postback and then navigated to a different page).  Customize
     * this method to allocate resources that will be required for rendering
     * this page.</p>
     */
    @Override
    public void prerender() {
    }

    /**
     * <p>Callback method that is called after rendering is completed for
     * this request, if <code>init()</code> was called (regardless of whether
     * or not this was the page that was actually rendered).  Customize this
     * method to release resources acquired in the <code>init()</code>,
     * <code>preprocess()</code>, or <code>prerender()</code> methods (or
     * acquired during execution of an event handler).</p>
     */
    @Override
    public void destroy() {
        usuarioDataProvider.close();
    }

    /**
     * <p>Return a reference to the scoped data bean.</p>
     *
     * @return reference to the scoped data bean
     */
    protected RequestBean1 getRequestBean1() {
        return (RequestBean1) getBean("RequestBean1");
    }

    /**
     * <p>Return a reference to the scoped data bean.</p>
     *
     * @return reference to the scoped data bean
     */
    protected SessionBean1 getSessionBean1() {
        return (SessionBean1) getBean("SessionBean1");
    }

    /**
     * <p>Return a reference to the scoped data bean.</p>
     *
     * @return reference to the scoped data bean
     */
    protected ApplicationBean1 getApplicationBean1() {
        return (ApplicationBean1) getBean("ApplicationBean1");
    }



    public String button2_action() {
        Map params = new HashMap();
        String result1, result2;
        SimpleDateFormat sdf = new SimpleDateFormat("yyyy/MM/dd");
        String nombre_Pac = getSessionBean1().getPacienteMy().getPacNombre().toString() +", " +getSessionBean1().getPacienteMy().getPacApellid().toString();
        try{
        
        if(grupOp.getValue().toString().equals("1")){
          
          result1 = sdf.format(cal_ini.getSelectedDate());      
          result2 = sdf.format(cal_fin.getSelectedDate());
                
          params.put("nombre_paciente", nombre_Pac);      
          params.put("fechainicio", result1);
          params.put("fechafin", result2);
          params.put("especialidad", getDdlEspecialidad().getValue().toString());
          params.put("paciente", getSessionBean1().getPacienteMy().getPacCodigo().toString()); 
          Especialidad espe = new Especialidad();
          Captura cap = new Captura();
          espe = cap.getEspecialidad(Integer.parseInt(getDdlEspecialidad().getValue().toString()));
          params.put("Nom_de_especialidad", espe.getEspNombre());
          
          
          String dataSourceName = "java:comp/env/jdbc/ppg_MySQL";

         
           getApplicationBean1().jasperReport(dataSourceName, params, grupOp.getValue().toString());
    
       
        }else if (grupOp.getValue().toString().equals("2")){ //por fecha
          
          
          result1 = sdf.format(cal_ini.getSelectedDate());      
          result2 = sdf.format(cal_fin.getSelectedDate());
                
          params.put("nombre_paciente", nombre_Pac);      
          params.put("fechainicio", result1);
          params.put("fechafin", result2);
          params.put("paciente", getSessionBean1().getPacienteMy().getPacCodigo().toString());       
          
          String dataSourceName = "java:comp/env/jdbc/ppg_MySQL";

           
           getApplicationBean1().jasperReport(dataSourceName, params,grupOp.getValue().toString() );

      }    else if (grupOp.getValue().toString().equals("3")){ //por fecha
          
          params.put("nombre_paciente", nombre_Pac);
          params.put("paciente", getSessionBean1().getPacienteMy().getPacCodigo().toString());       
          params.put("especialidad", getDdlEspecialidad().getValue().toString());
          Especialidad espe = new Especialidad();
          Captura cap = new Captura();
          espe = cap.getEspecialidad(Integer.parseInt(getDdlEspecialidad().getValue().toString()));
          params.put("Nom_de_especialidad", espe.getEspNombre());
          String dataSourceName = "java:comp/env/jdbc/ppg_MySQL";
 
           
           getApplicationBean1().jasperReport(dataSourceName, params,grupOp.getValue().toString() );
            
    }
      
    } catch (Exception ex) {
//          Logger.getLogger(Login.class.getName()).log(Level.SEVERE, null, ex);
//          error(ex.toString());
      }
        
      return null;
    }

    public String jliReserva1_action() {
        // TODO: Replace with your code
        return null;
    }

    public String jliSalir_action() {
        // TODO: Replace with your code
        return null;
    }

 




   

   


    
}




